package model;

import javax.persistence.Entity;
import javax.persistence.GeneratedValue;
import javax.persistence.GenerationType;
import javax.persistence.Id;
import javax.persistence.Table;

import play.db.jpa.GenericModel;

/**
 * @Description
 * @Author <a href="mailto:liuxiongfei@bus365.com">刘雄飞</a>
 * @Date 2017年8月15日上午10:31:31
 */
@Entity
@Table(name="qhstationdata")
public class Qhstationdata extends GenericModel{

	/**
	 * 
	 */
	private static final long serialVersionUID = 1L;
	@Id
	@GeneratedValue(strategy=GenerationType.AUTO)
	public Integer id;//int(11)NOTNULLAUTO_INCREMENTCOMMENT'自增主键',
	public String StationCode;//varchar(30)DEFAULTNULLCOMMENT'发车站编码',
	public String StationName;//varchar(50)DEFAULTNULLCOMMENT'发车站名称',
	public String MotorcoachName;//varchar(20)DEFAULTNULLCOMMENT'车次',
	public String VehicleNumber;//varchar(10)DEFAULTNULLCOMMENT'车牌号',
	public String VehicleType;//varchar(10)DEFAULTNULLCOMMENT'车型',
	public String VehicleColor;//varchar(5)DEFAULTNULLCOMMENT'车牌颜色',
	public String SeatNumber;//varchar(5)DEFAULTNULLCOMMENT'核载座位数',
	public String ActualSeatNumber;//varchar(5)DEFAULTNULLCOMMENT'实载乘客数',
	public String DepartDate;//dateDEFAULTNULLCOMMENT'发车日期',
	public String DepartTime;//datetimeDEFAULTNULLCOMMENT'发车时间',
	public String RouteName;//varchar(50)DEFAULTNULLCOMMENT'线路名称',
	public String RouteBegin;//varchar(50)DEFAULTNULLCOMMENT'线路起点',
	public String RouteEnd;//varchar(50)DEFAULTNULLCOMMENT'线路终点',
	public Integer RouteMileage;//int(11)DEFAULTNULLCOMMENT'里程',
	public String CertificatesFruit;//varchar(5)DEFAULTNULLCOMMENT'安检结果',
	public String DriverName;//varchar(20)DEFAULTNULLCOMMENT'驾驶员',
	public String DriverCredentialsNumber;//varchar(20)DEFAULTNULLCOMMENT'驾驶证号',
	public String QualifiCationCertificateNumber;//varchar(50)DEFAULTNULLCOMMENT'从业资格证号',
	public String RoadTransportLicenceNumber;//varchar(50)DEFAULTNULLCOMMENT'道路运输证号',
	public String TelePhone;//varchar(11)DEFAULTNULLCOMMENT'手机号码',
	public Long hashid;//bigint(20)DEFAULTNULLCOMMENT'哈希id，唯一标志一条记录',
}
